<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<HTML
><HEAD
><TITLE
>Overview</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
REV="MADE"
HREF="mailto:pgsql-docs@postgresql.org"><LINK
REL="HOME"
TITLE="PostgreSQL 9.1.2 Documentation"
HREF="index.html"><LINK
REL="UP"
TITLE="System Catalogs"
HREF="catalogs.html"><LINK
REL="PREVIOUS"
TITLE="System Catalogs"
HREF="catalogs.html"><LINK
REL="NEXT"
TITLE="pg_aggregate"
HREF="catalog-pg-aggregate.html"><LINK
REL="STYLESHEET"
TYPE="text/css"
HREF="stylesheet.css"><META
HTTP-EQUIV="Content-Type"
CONTENT="text/html; charset=ISO-8859-1"><META
NAME="creation"
CONTENT="2011-12-01T22:07:59"></HEAD
><BODY
CLASS="SECT1"
><DIV
CLASS="NAVHEADER"
><TABLE
SUMMARY="Header navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TH
COLSPAN="5"
ALIGN="center"
VALIGN="bottom"
><A
HREF="index.html"
>PostgreSQL 9.1.2 Documentation</A
></TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="top"
><A
TITLE="System Catalogs"
HREF="catalogs.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="top"
><A
HREF="catalogs.html"
ACCESSKEY="U"
>Up</A
></TD
><TD
WIDTH="60%"
ALIGN="center"
VALIGN="bottom"
>Chapter 45. System Catalogs</TD
><TD
WIDTH="20%"
ALIGN="right"
VALIGN="top"
><A
TITLE="pg_aggregate"
HREF="catalog-pg-aggregate.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><DIV
CLASS="SECT1"
><H1
CLASS="SECT1"
><A
NAME="CATALOGS-OVERVIEW"
>45.1. Overview</A
></H1
><P
>   <A
HREF="catalogs-overview.html#CATALOG-TABLE"
>Table 45-1</A
> lists the system catalogs.
   More detailed documentation of each catalog follows below.
  </P
><P
>   Most system catalogs are copied from the template database during
   database creation and are thereafter database-specific. A few
   catalogs are physically shared across all databases in a cluster;
   these are noted in the descriptions of the individual catalogs.
  </P
><DIV
CLASS="TABLE"
><A
NAME="CATALOG-TABLE"
></A
><P
><B
>Table 45-1. System Catalogs</B
></P
><TABLE
BORDER="1"
CLASS="CALSTABLE"
><COL><COL><THEAD
><TR
><TH
>Catalog Name</TH
><TH
>Purpose</TH
></TR
></THEAD
><TBODY
><TR
><TD
><A
HREF="catalog-pg-aggregate.html"
><TT
CLASS="STRUCTNAME"
>pg_aggregate</TT
></A
></TD
><TD
>aggregate functions</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-am.html"
><TT
CLASS="STRUCTNAME"
>pg_am</TT
></A
></TD
><TD
>index access methods</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-amop.html"
><TT
CLASS="STRUCTNAME"
>pg_amop</TT
></A
></TD
><TD
>access method operators</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-amproc.html"
><TT
CLASS="STRUCTNAME"
>pg_amproc</TT
></A
></TD
><TD
>access method support procedures</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-attrdef.html"
><TT
CLASS="STRUCTNAME"
>pg_attrdef</TT
></A
></TD
><TD
>column default values</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-attribute.html"
><TT
CLASS="STRUCTNAME"
>pg_attribute</TT
></A
></TD
><TD
>table columns (<SPAN
CLASS="QUOTE"
>"attributes"</SPAN
>)</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-authid.html"
><TT
CLASS="STRUCTNAME"
>pg_authid</TT
></A
></TD
><TD
>authorization identifiers (roles)</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-auth-members.html"
><TT
CLASS="STRUCTNAME"
>pg_auth_members</TT
></A
></TD
><TD
>authorization identifier membership relationships</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-cast.html"
><TT
CLASS="STRUCTNAME"
>pg_cast</TT
></A
></TD
><TD
>casts (data type conversions)</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-class.html"
><TT
CLASS="STRUCTNAME"
>pg_class</TT
></A
></TD
><TD
>tables, indexes, sequences, views (<SPAN
CLASS="QUOTE"
>"relations"</SPAN
>)</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-constraint.html"
><TT
CLASS="STRUCTNAME"
>pg_constraint</TT
></A
></TD
><TD
>check constraints, unique constraints, primary key constraints, foreign key constraints</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-collation.html"
><TT
CLASS="STRUCTNAME"
>pg_collation</TT
></A
></TD
><TD
>collations (locale information)</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-conversion.html"
><TT
CLASS="STRUCTNAME"
>pg_conversion</TT
></A
></TD
><TD
>encoding conversion information</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-database.html"
><TT
CLASS="STRUCTNAME"
>pg_database</TT
></A
></TD
><TD
>databases within this database cluster</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-db-role-setting.html"
><TT
CLASS="STRUCTNAME"
>pg_db_role_setting</TT
></A
></TD
><TD
>per-role and per-database settings</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-default-acl.html"
><TT
CLASS="STRUCTNAME"
>pg_default_acl</TT
></A
></TD
><TD
>default privileges for object types</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-depend.html"
><TT
CLASS="STRUCTNAME"
>pg_depend</TT
></A
></TD
><TD
>dependencies between database objects</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-description.html"
><TT
CLASS="STRUCTNAME"
>pg_description</TT
></A
></TD
><TD
>descriptions or comments on database objects</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-enum.html"
><TT
CLASS="STRUCTNAME"
>pg_enum</TT
></A
></TD
><TD
>enum label and value definitions</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-extension.html"
><TT
CLASS="STRUCTNAME"
>pg_extension</TT
></A
></TD
><TD
>installed extensions</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-foreign-data-wrapper.html"
><TT
CLASS="STRUCTNAME"
>pg_foreign_data_wrapper</TT
></A
></TD
><TD
>foreign-data wrapper definitions</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-foreign-server.html"
><TT
CLASS="STRUCTNAME"
>pg_foreign_server</TT
></A
></TD
><TD
>foreign server definitions</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-foreign-table.html"
><TT
CLASS="STRUCTNAME"
>pg_foreign_table</TT
></A
></TD
><TD
>additional foreign table information</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-index.html"
><TT
CLASS="STRUCTNAME"
>pg_index</TT
></A
></TD
><TD
>additional index information</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-inherits.html"
><TT
CLASS="STRUCTNAME"
>pg_inherits</TT
></A
></TD
><TD
>table inheritance hierarchy</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-language.html"
><TT
CLASS="STRUCTNAME"
>pg_language</TT
></A
></TD
><TD
>languages for writing functions</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-largeobject.html"
><TT
CLASS="STRUCTNAME"
>pg_largeobject</TT
></A
></TD
><TD
>data pages for large objects</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-largeobject-metadata.html"
><TT
CLASS="STRUCTNAME"
>pg_largeobject_metadata</TT
></A
></TD
><TD
>metadata for large objects</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-namespace.html"
><TT
CLASS="STRUCTNAME"
>pg_namespace</TT
></A
></TD
><TD
>schemas</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-opclass.html"
><TT
CLASS="STRUCTNAME"
>pg_opclass</TT
></A
></TD
><TD
>access method operator classes</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-operator.html"
><TT
CLASS="STRUCTNAME"
>pg_operator</TT
></A
></TD
><TD
>operators</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-opfamily.html"
><TT
CLASS="STRUCTNAME"
>pg_opfamily</TT
></A
></TD
><TD
>access method operator families</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-pltemplate.html"
><TT
CLASS="STRUCTNAME"
>pg_pltemplate</TT
></A
></TD
><TD
>template data for procedural languages</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-proc.html"
><TT
CLASS="STRUCTNAME"
>pg_proc</TT
></A
></TD
><TD
>functions and procedures</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-rewrite.html"
><TT
CLASS="STRUCTNAME"
>pg_rewrite</TT
></A
></TD
><TD
>query rewrite rules</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-seclabel.html"
><TT
CLASS="STRUCTNAME"
>pg_seclabel</TT
></A
></TD
><TD
>security labels on database objects</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-shdepend.html"
><TT
CLASS="STRUCTNAME"
>pg_shdepend</TT
></A
></TD
><TD
>dependencies on shared objects</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-shdescription.html"
><TT
CLASS="STRUCTNAME"
>pg_shdescription</TT
></A
></TD
><TD
>comments on shared objects</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-statistic.html"
><TT
CLASS="STRUCTNAME"
>pg_statistic</TT
></A
></TD
><TD
>planner statistics</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-tablespace.html"
><TT
CLASS="STRUCTNAME"
>pg_tablespace</TT
></A
></TD
><TD
>tablespaces within this database cluster</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-trigger.html"
><TT
CLASS="STRUCTNAME"
>pg_trigger</TT
></A
></TD
><TD
>triggers</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-ts-config.html"
><TT
CLASS="STRUCTNAME"
>pg_ts_config</TT
></A
></TD
><TD
>text search configurations</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-ts-config-map.html"
><TT
CLASS="STRUCTNAME"
>pg_ts_config_map</TT
></A
></TD
><TD
>text search configurations' token mappings</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-ts-dict.html"
><TT
CLASS="STRUCTNAME"
>pg_ts_dict</TT
></A
></TD
><TD
>text search dictionaries</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-ts-parser.html"
><TT
CLASS="STRUCTNAME"
>pg_ts_parser</TT
></A
></TD
><TD
>text search parsers</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-ts-template.html"
><TT
CLASS="STRUCTNAME"
>pg_ts_template</TT
></A
></TD
><TD
>text search templates</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-type.html"
><TT
CLASS="STRUCTNAME"
>pg_type</TT
></A
></TD
><TD
>data types</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-user-mapping.html"
><TT
CLASS="STRUCTNAME"
>pg_user_mapping</TT
></A
></TD
><TD
>mappings of users to foreign servers</TD
></TR
></TBODY
></TABLE
></DIV
></DIV
><DIV
CLASS="NAVFOOTER"
><HR
ALIGN="LEFT"
WIDTH="100%"><TABLE
SUMMARY="Footer navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><A
HREF="catalogs.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="index.html"
ACCESSKEY="H"
>Home</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="catalog-pg-aggregate.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>System Catalogs</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="catalogs.html"
ACCESSKEY="U"
>Up</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><TT
CLASS="STRUCTNAME"
>pg_aggregate</TT
></TD
></TR
></TABLE
></DIV
></BODY
></HTML
>